Note: This function assumes a Business Calendar has been set up for your system. Currently, the Business Calendar is only supported in Seagate Info but not in Crystal Reports. If you are using this function in Crystal Reports, or if you have not specified a Business Calendar for your Seagate Info system, this function assumes everyday is a business day.
Evaluates the date specified in the argument, and returns TRUE if the Date value falls on a business day.
You can use this function in a record selection formula to limit the report to records for business days, or to records that are not for business days.
The following examples are applicable to both Basic and Crystal syntax:
IsBusinessDay({Customer.ORDER DATE})
Returns TRUE, where {Customer.ORDER DATE} has a value of 10/14/98, and is specified to be a business day according the Business Calendar for your system.
IsBusinessDay({Customer.ORDER DATE})
Returns FALSE, where {Customer.ORDER DATE} has a value of 10/18/98 which is a Sunday, and is specified to be a non
Currently, this function only accepts a date but not a dateTime field as an argument.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |